CREATE TABLE daycare.Addresses
  (
   AddressId INT NOT NULL
                 IDENTITY(1,1)
                 PRIMARY KEY
 , StreetAddressOne VARCHAR(200) NULL
 , StreetAddressTwo VARCHAR(200)
 , City VARCHAR(100) NULL
 , State VARCHAR(2) NULL
 , ZipCode VARCHAR(10) NULL
 , AddressTypeId INT NOT NULL
  )

ALTER TABLE daycare.Addresses ADD CONSTRAINT FK_Addresses_AddressTypes FOREIGN KEY(AddressTypeId) REFERENCES daycare.AddressTypes(AddressTypeId)
GO
